Generate Sales Target from Parity 

Overview

This application takes target weekly sales across a range of weeks and allocates it by day within stores based on their parity value and historic sales by day.

Criteria Form

The following table describes the form fields:-

Column	Description
Start Week	This is the start week to generate the targets.
Number of Weeks	The number of week’s field is where the user chooses the number of weeks that they wish to generate sales targets for.  The options here are four weeks or five weeks.
Option	The option field is where the user chooses to ‘create new targets’ or ‘edit existing targets’.
Week 1 to Week 6 company Target	The Week number company target is where the user enters in the projected company total.  This will include Tax.  The user will need to enter a value for each of the weekly target fields.
Analyse From Week Beginning to Ending	The analyse from and to fields are used to allocate weekly targets to days based on the average sales by day over the analysis period.  For example if on average 15% of a week’s sales occurred on a Monday in an analysis range for a given store, then 15% of the weekly sales would be allocated to Monday of that store.

Report

Regardless of the option selected within the criteria form the report will display.

The report is consolidated by region and the individual stores listed within each region.  To the right of the store names are the weeks generated sales targets.  If the user chose four weeks on the criteria form they will see four columns if they chose five weeks they will see five.   At any point the user can go back to the criteria form and generate new targets.

Remarks

Technical Reference

This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.

See Also